<html><head><title>select with union</title><meta name="HandheldFriendly" content="True"></head><body>Returns a single result set that combines the result of two or more queries. Duplicate rows are eliminated from the result set unless the all keyword is specified.<br><br>start_of_select_statement [<a href="q307684.html">group by</a>] [<a href="q307685.html">having clause</a>] [<b>union</b> [<b>all</b>] start_of_select_statement [<a href="q307684.html">group by</a>] [<a href="q307685.html">having clause</a>]]... [<a href="q307686.html">order by</a>] [<a href="q307683.html">compute</a>] </body></html>